﻿USE RENTIT11;
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0468569', 'The Dark Knight', 2008, 152, 'English', 'PG13', 'Batman, Gordon and Harvey Dent are forced to deal with the chaos unleashed by a terrorist mastermind known only as the Joker, as he drives each of them to their limits.', 1, '2008-07-22'); 
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0114369', 'Se7en', 1995, 127, 'English', 'R', 'Two detectives, a rookie and a veteran, hunt a serial killer who uses the seven deadly sins as his modus operandi.', 0, '1996-03-08');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0137523', 'Fight Club', 1999, 139, 'English', 'R', 'An office employee and a soap salesman build a global organization to help vent male aggression.', 0, '1999-11-05');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt1375666', 'Inception', 2010, 148, 'English', 'PG13', 'In a world where technology exists to enter the human mind through dream invasion, a highly skilled thief is given a final chance at redemption which involves executing his toughest job to date: Inception.', 1, '2009-07-29');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0111161', 'The Shawshank Redemption', 1994, 142, 'English', 'R', 'Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.', 0, '1995-04-28');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0110912', 'Pulp Fiction', 1994, 154, 'English', 'R', 'The lives of two mob hit men, a boxer, a gangsters wife, and a pair of diner bandits intertwine in four tales of violence and redemption.', 0, '1994-10-28');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0372784', 'Batman Begins', 2005, 140, 'English', 'PG13', 'Bruce Wayne has watched his home, Gotham City, turn into a crime infested abyss throughout his entire life, so he decides to become the hero Gotham needs- Batman.', 1, '2005-07-22');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0209144', 'Memento', 2000, 113, 'English', 'R', 'A man, suffering from short-term memory loss, uses notes and tattoos to hunt for the man he thinks killed his wife.', 1, '2001-04-20');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0482571', 'The Prestige', 2006, 130, 'English', 'PG13', 'The rivalry between two magicians is exacerbated when one of them performs the ultimate illusion.', 1, '2007-01-05');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0120815', 'Saving Private Ryan', 1998, 169, 'English', 'R', 'Following the Normandy Landings, a group of US soldiers go behind enemy lines to retrieve a paratrooper whose brothers have been killed in action.', 0, '1998-10-23');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt1699135', 'Klassefesten', 2011, 90, 'Danish', 'G', 'The three high school buddies Niels, Andreas and Thomas are invited to the mandatory 25 year anniversary', 1, '2011-10-13');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt1119646', 'The Hangover', 2009, 100, 'English', 'R', 'A Las Vegas-set comedy centered around three groomsmen who lose their about-to-be-wed buddy during their drunken misadventures, then must retrace their steps in order to find him.', 1, '2009-07-24');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt1541160', 'Flypaper', 2011, 87, 'English', 'G', 'A man caught in the middle of two simultaneous robberies at the same bank desperately tries to protect the teller with whom he is secretly in love.', 1, '2011-08-26'); 
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0099685', 'Goodfellas', 1990, 146, 'English', 'R', 'Henry Hill and his friends work their way up through the mob hierarchy.', 0, '1990-11-09');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0133093', 'The Matrix', 1999, 136, 'English', 'R', 'A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.', 0, '1999-05-07');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0114814', 'The Usual Suspects', 1995, 106, 'English', 'R', 'A boat has been destroyed, criminals are dead, and the key to this mystery lies with the only survivor and his twisted, convoluted story beginning with five career crooks in a seemingly random police lineup.', 0, '1995-12-25');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0109830', 'Forrest Gump', 1994, 142, 'English', 'PG13', 'Forrest Gump, while not intelligent, has accidentally been present at many historic moments, but his true love, Jenny, eludes him.', 0, '1994-10-07');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0120586', 'American History X', 1998, 119, 'English', 'R', 'A former neo-nazi skinhead tries to prevent his younger brother from going down the same wrong path that he did.', 0, '1999-02-12');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0435761', 'Toy Story 3', 2010, 103, 'English', 'G', 'The toys are mistakenly delivered to a day-care center instead of the attic right before Andy leaves for college, and its up to Woody to convince the other toys that they werent abandoned and to return home.', 1, '2010-08-26');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0382932', 'Ratatouille', 2007, 111, 'English', 'G', 'Remy is a young rat in the French countryside who arrives in Paris, only to find out that his cooking idol is dead. When he makes an unusual alliance with a restaurants new garbage boy, the culinary and personal adventures begin despite Remys familys skepticism and the rat-hating world of humans.', 1, '2007-10-05');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0169547', 'American Beauty', 1999, 122, 'English', 'R', 'Lester Burnham, a depressed suburban father in a mid-life crisis, decides to turn his hectic life around after developing an infatuation for his daughters attractive friend.', 0, '2000-02-18');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0253474', 'The Pianist', 2002, 150, 'English', 'R', 'A Polish Jewish musician struggles to survive the destruction of the Warsaw ghetto of World War II.', 1, '2003-07-04');
GO

INSERT INTO MOVIE (imdb, title, movieyear, movielength, movielanguage, pg, summary, hd, releasedate)
VALUES ('tt0407887', 'The Departed', 2006, 151, 'English', 'R', 'Two men from opposite sides of the law are undercover within the Massachusetts State Police and the Irish mafia, but violence and bloodshed boil when discoveries are made, and the moles are dispatched to find out their enemys identities.', 1, '2006-11-10');
GO

INSERT INTO GENRE (name)
VALUES ('Action');
GO

INSERT INTO GENRE (name)
VALUES ('Adventure');
GO

INSERT INTO GENRE (name)
VALUES ('Animation');
GO

INSERT INTO GENRE (name)
VALUES ('Biography');
GO

INSERT INTO GENRE (name)
VALUES ('Crime');
GO

INSERT INTO GENRE (name)
VALUES ('Comedy');
GO

INSERT INTO GENRE (name)
VALUES ('Drama');
GO

INSERT INTO GENRE (name)
VALUES ('Fantasy');
GO

INSERT INTO GENRE (name)
VALUES ('History');
GO

INSERT INTO GENRE (name)
VALUES ('Mystery');
GO

INSERT INTO GENRE (name)
VALUES ('Romance');
GO

INSERT INTO GENRE (name)
VALUES ('Sci-Fi');
GO

INSERT INTO GENRE (name)
VALUES ('Thriller');
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Morten', dbo.md5('12345' + dbo.md5('kodeord')), '1990-10-01', 'mche@itu.dk', '12345', 1);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES('Andreas', dbo.md5('34567' + dbo.md5('kjeldsen')), '1990-09-21', 'ahal@itu.dk', '34567', 1);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Michael', dbo.md5('12345' + dbo.md5('mortensen')), '1990-03-01', 'miur@itu.dk', '12345', 1);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Claus', dbo.md5('12345' + dbo.md5('wind')), '1990-02-06', 'clbw@itu.dk', '12345', 1);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Asger', dbo.md5('12345' + dbo.md5('sand')), '1990-12-03', 'asgs@itu.dk', '12345', 1);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Anders', dbo.md5('12345' + dbo.md5('hansen')), '1987-04-04', 'andeh@gmail.com', '12345', 0);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Megan', dbo.md5('12345' + dbo.md5('meganfox')), '1986-11-28', 'foxy@gmail.com', '12345', 0);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Scarlett', dbo.md5('12345' + dbo.md5('johansson')), '1983-06-11', 'scar@gmail.com', '12345', 0);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Morgan', dbo.md5('12345' + dbo.md5('freeman')), '1970-07-20', 'freeman@gmail.com', '12345', 0);
GO

INSERT INTO USERINFO (name, pwhash, birthdate, email, salt, isadmin)
VALUES ('Tiesto', dbo.md5('12345' + dbo.md5('djtiesto')), '1978-04-25', 'tiesto@gmail.com', '12345', 0);
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Dark Knight'), (SELECT id FROM GENRE WHERE name = 'Action'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Dark Knight'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Dark Knight'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Se7en'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Se7en'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Se7en'), (SELECT id FROM GENRE WHERE name = 'Thriller'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Fight Club'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Inception'), (SELECT id FROM GENRE WHERE name = 'Action'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Inception'), (SELECT id FROM GENRE WHERE name = 'Adventure'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Inception'), (SELECT id FROM GENRE WHERE name = 'Sci-Fi'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Shawshank Redemption'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Shawshank Redemption'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Pulp Fiction'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Pulp Fiction'), (SELECT id FROM GENRE WHERE name = 'Thriller'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Batman Begins'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Batman Begins'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Batman Begins'), (SELECT id FROM GENRE WHERE name = 'Action'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Memento'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Memento'), (SELECT id FROM GENRE WHERE name = 'Mystery'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Memento'), (SELECT id FROM GENRE WHERE name = 'Thriller'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Prestige'), (SELECT id FROM GENRE WHERE name = 'Thriller'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Prestige'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Prestige'), (SELECT id FROM GENRE WHERE name = 'Mystery'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Saving Private Ryan'), (SELECT id FROM GENRE WHERE name = 'History'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Saving Private Ryan'), (SELECT id FROM GENRE WHERE name = 'Action'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Saving Private Ryan'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Klassefesten'), (SELECT id FROM GENRE WHERE name = 'Comedy'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Hangover'), (SELECT id FROM GENRE WHERE name = 'Comedy'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Flypaper'), (SELECT id FROM GENRE WHERE name = 'Comedy'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Flypaper'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Goodfellas'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Goodfellas'), (SELECT id FROM GENRE WHERE name = 'Biography'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Goodfellas'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Matrix'), (SELECT id FROM GENRE WHERE name = 'Action'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Matrix'), (SELECT id FROM GENRE WHERE name = 'Adventure'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Matrix'), (SELECT id FROM GENRE WHERE name = 'Sci-Fi'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Usual Suspects'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Usual Suspects'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Usual Suspects'), (SELECT id FROM GENRE WHERE name = 'Mystery'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Forrest Gump'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Forrest Gump'), (SELECT id FROM GENRE WHERE name = 'Comedy'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Forrest Gump'), (SELECT id FROM GENRE WHERE name = 'Romance'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'American History X'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'American History X'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Toy Story 3'), (SELECT id FROM GENRE WHERE name = 'Comedy'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Toy Story 3'), (SELECT id FROM GENRE WHERE name = 'Animation'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Toy Story 3'), (SELECT id FROM GENRE WHERE name = 'Adventure'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Ratatouille'), (SELECT id FROM GENRE WHERE name = 'Animation'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'Ratatouille'), (SELECT id FROM GENRE WHERE name = 'Comedy'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'American Beauty'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Pianist'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Pianist'), (SELECT id FROM GENRE WHERE name = 'Biography'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Pianist'), (SELECT id FROM GENRE WHERE name = 'History'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Departed'), (SELECT id FROM GENRE WHERE name = 'Drama'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Departed'), (SELECT id FROM GENRE WHERE name = 'Crime'));
GO

INSERT INTO MOVIEGENRE (movieid, genreid)
VALUES ((SELECT id FROM MOVIE WHERE title = 'The Departed'), (SELECT id FROM GENRE WHERE name = 'Mystery'));
GO

INSERT INTO RATING (userid, movieid, rating, comment)
VALUES ((SELECT id FROM USERINFO WHERE name = 'Morten'), (SELECT id FROM MOVIE WHERE title = 'The Dark Knight'), 5, 'Awesome movie.');
GO

INSERT INTO RATING (userid, movieid, rating, comment)
VALUES ((SELECT id FROM USERINFO WHERE name = 'Andreas'), (SELECT id FROM MOVIE WHERE title = 'Fight Club'), 2, 'Looove Edward Norton, but the movie not so much.');
GO

INSERT INTO RATING (userid, movieid, rating, comment)
VALUES ((SELECT id FROM USERINFO WHERE name = 'Claus'), (SELECT id FROM MOVIE WHERE title = 'The Hangover'), 4, 'Funny stuff.');
GO

INSERT INTO RATING (userid, movieid, rating, comment)
VALUES ((SELECT id FROM USERINFO WHERE name = 'Michael'), (SELECT id FROM MOVIE WHERE title = 'Saving Private Ryan'), 3, 'Tom Hanks is awesome.');
GO

INSERT INTO RATING (userid, movieid, rating, comment)
VALUES ((SELECT id FROM USERINFO WHERE name = 'Asger'), (SELECT id FROM MOVIE WHERE title = 'Flypaper'), 1, 'This movie sucks.');
GO